FaShoppingSheetConsumer 
EntityType  Independent 
Logical Entity Name  FaShoppingSheetConsumer 
Default Table Name  FaShoppingSheetConsumer 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

FaShoppingSheetConsumer Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
FaShoppingSheetConsumerID(PK)    CHAR(10)  NO 
 
OpeId    CHAR(10)  NO 
 
UnitdId    CHAR(10)  NO 
 
GraduationRate    CHAR(10)  YES 
 
GRGroupLow    CHAR(10)  YES 
 
GRGroupLowToMedium    CHAR(10)  YES 
 
GRGroupMediumToHigh    CHAR(10)  YES 
 
GRGroupHigh    CHAR(10)  YES 
 
SchoolCDR    CHAR(10)  YES 
 
NationalAverageCDR    CHAR(10)  YES 
 
MedianTotalBorrowing    CHAR(10)  YES 
 
MedianMonthlyPayment    CHAR(10)  YES 
 
InstitutionGroup    CHAR(10)  NO 
 
DateAdded    CHAR(10)  NO 
 
ts    CHAR(10)  NO 
 
VersionNumber    CHAR(10)  YES 
 
GRGroup    CHAR(10)  YES 
 
Group_Avg_RPY_3YR_RT    CHAR(10)  YES 
 
School_RPY_3YR_RT    CHAR(10)  YES 
 
Nat_Avg_RPY_3YR_RT    CHAR(10)  YES 
 

FaShoppingSheetConsumer Keys 
Key Name  Key Type  Keys 
PK_FaShoppingSheetConsumer_FaShoppingSheetConsumerID  PrimaryKey  FaShoppingSheetConsumerID 

FaShoppingSheetConsumer Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

FaShoppingSheetConsumer Check Constraints 
Check Constraint Name  CheckConstraint 

FaShoppingSheetConsumer Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.FaShoppingSheetConsumer 
NO       
Physical (Microsoft SQL Server)
Does Not Exist 
NO       

FaShoppingSheetConsumer Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 

FaShoppingSheetConsumer Data Movement Rules 
Name  Type  Rule Text/Value